Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Description 2' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DESCRIPTION 2

Seq No	Page Number	Page Name	Control Name
1	30	Item Card	Description 2
2	31	Item List	Description 2
3	35	Item Translations	Description 2
4	46	Sales Order Subform	Description 2
5	47	Sales Invoice Subform	Description 2
6	48	Sales Orders	Description 2
7	54	Purchase Order Subform	Description 2
8	55	Purch. Invoice Subform	Description 2
9	56	Purchase Orders	Description 2
10	95	Sales Quote Subform	Description 2
11	96	Sales Cr. Memo Subform	Description 2
12	97	Purchase Quote Subform	Description 2
13	98	Purch. Cr. Memo Subform	Description 2
14	131	Posted Sales Shpt. Subform	Description 2
15	133	Posted Sales Invoice Subform	Description 2
16	135	Posted Sales Cr. Memo Subform	Description 2
17	137	Posted Purchase Rcpt. Subform	Description 2
18	139	Posted Purch. Invoice Subform	Description 2
19	141	Posted Purch. Cr. Memo Subform	Description 2
20	201	Job Journal	Description 2
21	291	Req. Worksheet	Description 2
22	296	Recurring Req. Worksheet	Description 2
23	305	Reservation Worksheet	Description 2
24	508	Blanket Sales Order Subform	Description 2
25	510	Blanket Purchase Order Subform	Description 2
26	516	Sales Lines	Description 2
27	517	Requisition Lines	Description 2
28	518	Purchase Lines	Description 2
29	525	Posted Sales Shipment Lines	Description 2
30	526	Posted Sales Invoice Lines	Description 2
31	527	Posted Sales Credit Memo Lines	Description 2
32	528	Posted Purchase Receipt Lines	Description 2
33	529	Posted Purchase Invoice Lines	Description 2
34	530	Posted Purchase Cr. Memo Lines	Description 2
35	637	IC Outbox Sales Lines	Description 2
36	639	IC Outbox Purchase Lines	Description 2
37	641	Handled IC Outbox Sales Lines	Description 2
38	643	Handled IC Outbox Purch. Lines	Description 2
39	645	IC Inbox Sales Lines	Description 2
40	647	IC Inbox Purchase Lines	Description 2
41	649	Handled IC Inbox Sales Lines	Description 2
42	651	Handled IC Inbox Purch. Lines	Description 2
43	734	VAT Clauses by Doc. Type	Description 2
44	735	VAT Clause by Doc. Type Trans.	Description 2
45	735	VAT Clause by Doc. Type Trans.	Description 2
46	747	VAT Clauses	Description 2
47	748	VAT Clause Translations	Description 2
48	847	Cash Flow Forecast Card	Description 2
49	849	Cash Flow Forecast List	Description 2
50	900	Assembly Order	Description 2
51	901	Assembly Order Subform	Description 2
52	902	Assembly Orders	Description 2
53	903	Assembly Lines	Description 2
54	904	Assembly List	Description 2
55	914	Assemble-to-Order Lines	Description 2
56	921	Posted Assembly Order Subform	Description 2
57	930	Assembly Quote	Description 2
58	931	Assembly Quote Subform	Description 2
59	932	Assembly Quotes	Description 2
60	940	Blanket Assembly Order	Description 2
61	941	Blanket Assembly Order Subform	Description 2
62	942	Blanket Assembly Orders	Description 2
63	1007	Job Planning Lines	Description 2
64	2114	O365 Posted Sales Inv. Lines	Description 2
65	2304	BC O365 Posted Sale Inv. Lines	Description 2
66	5160	Sales Order Archive Subform	Description 2
67	5163	Sales Quote Archive Subform	Description 2
68	5165	Purchase Quote Archive Subform	Description 2
69	5168	Purchase Order Archive Subform	Description 2
70	5401	Item Variants	Description 2
71	5405	Item Variant Card	Description 2
72	5406	Prod. Order Line List	Description 2
73	5708	Get Shipment Lines	Description 2
74	5709	Get Receipt Lines	Description 2
75	5735	Item Reference List	Description 2
76	5736	Item References	Description 2
77	5737	Item Reference Entries	Description 2
78	5741	Transfer Order Subform	Description 2
79	5744	Posted Transfer Shpt. Subform	Description 2
80	5746	Posted Transfer Rcpt. Subform	Description 2
81	5749	Transfer Lines	Description 2
82	5758	Posted Transfer Shipment Lines	Description 2
83	5759	Posted Transfer Receipt Lines	Description 2
84	5769	Whse. Receipt Subform	Description 2
85	5785	Warehouse Activity Lines	Description 2
86	5796	Registered Put-away Subform	Description 2
87	5799	Registered Pick Subform	Description 2
88	5806	Purch. Receipt Lines	Description 2
89	5824	Sales Shipment Lines	Description 2
90	5851	Get Post.Doc – S.ShptLn Sbfrm	Description 2
91	5852	Get Post.Doc – S.InvLn Subform	Description 2
92	5853	Get Pst.Doc-RtrnRcptLn Subform	Description 2
93	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Description 2
94	5856	Get Post.Doc – P.RcptLn Sbfrm	Description 2
95	5857	Get Post.Doc – P.InvLn Subform	Description 2
96	5858	Get Pst.Doc-RtrnShptLn Subform	Description 2
97	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Description 2
98	5877	Physical Inventory Order Subf.	Description 2
99	5878	Physical Inventory Order Lines	Description 2
100	5881	Phys. Invt. Recording Subform	Description 2
101	5882	Phys. Invt. Recording Lines	Description 2
102	5885	Posted Phys. Invt. Order Subf.	Description 2
103	5886	Posted Phys. Invt. Order Lines	Description 2
104	5889	Posted Phys. Invt. Rec. Subf.	Description 2
105	5890	Posted Phys. Invt. Rec. Lines	Description 2
106	5902	Service Order Subform	Description 2
107	5903	Service Item Lines	Description 2
108	5905	Service Lines	Description 2
109	5907	Service Item Worksheet Subform	Description 2
110	5922	Loaner Card	Description 2
111	5923	Loaner List	Description 2
112	5934	Service Invoice Subform	Description 2
113	5936	Service Credit Memo Subform	Description 2
114	5949	Posted Serv. Shpt. Line List	Description 2
115	5951	Posted Service Invoice Lines	Description 2
116	5952	Posted Service Cr. Memo Lines	Description 2
117	5965	Service Quote Subform	Description 2
118	5966	Service Quote Lines	Description 2
119	5970	Posted Service Shipment Lines	Description 2
120	5973	Posted Serv. Cr. Memo Subform	Description 2
121	5976	Posted Service Shpt. Subform	Description 2
122	5979	Posted Service Invoice Subform	Description 2
123	5994	Get Service Shipment Lines	Description 2
124	6036	Service Lines Subform	Description 2
125	6037	Service Shipment Lines Subform	Description 2
126	6038	Service Invoice Lines Subform	Description 2
127	6039	Service Cr. Memo Lines Subform	Description 2
128	6619	Sales Line Archive List	Description 2
129	6621	Blanket Sales Order Arch. Sub.	Description 2
130	6624	Blanket Purch. Order Arch.Sub.	Description 2
131	6626	Purchase Line Archive List	Description 2
132	6628	Sales Return Order Arc Subform	Description 2
133	6631	Sales Return Order Subform	Description 2
134	6638	Get Return Receipt Lines	Description 2
135	6641	Purchase Return Order Subform	Description 2
136	6643	Purchase Return Orders	Description 2
137	6645	Purch Return Order Arc Subform	Description 2
138	6648	Get Return Shipment Lines	Description 2
139	6651	Posted Return Shipment Subform	Description 2
140	6653	Posted Return Shipment Lines	Description 2
141	6657	Return Shipment Lines	Description 2
142	6661	Posted Return Receipt Subform	Description 2
143	6663	Posted Return Receipt Lines	Description 2
144	6667	Return Receipt Lines	Description 2
145	7331	Posted Whse. Receipt Subform	Description 2
146	7336	Whse. Shipment Subform	Description 2
147	7338	Posted Whse. Shipment Subform	Description 2
148	7341	Whse. Shipment Lines	Description 2
149	7342	Whse. Receipt Lines	Description 2
150	7345	Pick Worksheet	Description 2
151	7350	Registered Movement Subform	Description 2
152	7351	Movement Worksheet	Description 2
153	7352	Put-away Worksheet	Description 2
154	7355	Internal Put-away Subform	Description 2
155	7360	Whse. Internal Pick Lines	Description 2
156	7361	Whse. Internal Put-away Lines	Description 2
157	7362	Posted Whse. Shipment Lines	Description 2
158	7363	Posted Whse. Receipt Lines	Description 2
159	7364	Registered Whse. Act.-Lines	Description 2
160	7383	Invt. Movement Subform	Description 2
161	7385	Reg. Invt. Movement Subform	Description 2
162	7387	Reg. Invt. Movement Lines	Description 2
163	7391	Posted Invt. Put-away Subform	Description 2
164	7393	Posted Invt. Pick Subform	Description 2
165	7396	Posted Invt. Put-away Lines	Description 2
166	7397	Posted Invt. Pick Lines	Description 2
167	7398	Internal Movement Subform	Description 2
168	99000787	Production BOM List	Description 2
169	99000790	Family	Description 2
170	99000790	Family	Description 2
171	99000791	Family List	Description 2
172	99000792	Family Lines	Description 2
173	99000793	Family Line List	Description 2
174	99000813	Planned Production Order	Description 2
175	99000814	Planned Prod. Order Lines	Description 2
176	99000829	Firm Planned Prod. Order	Description 2
177	99000830	Firm Planned Prod. Order Lines	Description 2
178	99000831	Released Production Order	Description 2
179	99000832	Released Prod. Order Lines	Description 2
180	99000852	Planning Worksheet	Description 2
181	99000860	Planning Worksheet Line List	Description 2
182	99000867	Finished Production Order	Description 2
183	99000868	Finished Prod. Order Lines	Description 2
184	99000886	Subcontracting Worksheet	Description 2
185	99000912	Simulated Production Order	Description 2
186	99000913	Simulated Prod. Order Lines	Description 2

Dynamics 365 BC Table ReferencePage Control Search